# name : SQL merge one to one or many
# key : sql.merge.one.to.many
# contributor: Shuguang Sun
# --
proc sql;
  create table ${1:dtout} as
    select *
    from ${2:dtin1} as a, ${3:dtin2} as b
    where a.${4:usubjid} = b.$4
    order by a.$4;
  quit;
run;